package com.etl.constants;

public class CommonConstant {

    public static final String CACHE_PREFIX = "ETL";

    public static final String COOKIE_KEY = "ETL_VERIFY";

    public static final String DWPREFIX = "DW";

    public static final String CONNECTION = "_";

    public static final String NAMENEW = "NEW";

    public static final String NAMEOLD = "OLD";

    public static final int COMMITSIZE = 5000;

    public static final String ALERT = "ALTER TABLE ";

    public static final String RENAME = " RENAME TO ";

    public static final String EXEC_SP_RENAME = "exec sp_rename ";

    public static final String COMMA = ",";


    public static final int EXECFLAG = 0;

    /*************数据库****************/

    public static final String ORACLE_DRIVER = "oracle.jdbc.driver.OracleDriver";

    public static final String ORACLE_URL = "jdbc:oracle:thin:@//%s:%s/%s";

    public static final String MSSQL_DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

    public static final String MSSQL_URL = "jdbc:sqlserver://%s:%s;databaseName=%s";

    public static final String MYSQL_DRIVER = "com.mysql.jdbc.Driver";

    public static final String MYSQL_URL = "jdbc:mysql://%s:%s/%s?useUnicode=true&autoReconnect=true&useSSL=false";

    public static final String ORACLE_NAME = "oracle";

    public static final String MYSQL_NAME = "mysql";

    public static final String MSSQL_NAME = "mssql";
}
